|
Question |
Rating |
View Answer |
|
What is parameter file?
|
|
View Answer |
|
What r the tasks that Loadmanger process will do?
|
|
View Answer |
|
In a joiner transformation, you should specify the source with fewer rows as the master source. Why?
|
|
View Answer |
|
Informatica Live Interview Questions
|
|
View Answer |
|
I have a situation here to load the Table into informatica.
I have 5 temporary tables as sources. They look like:
Table1: (K - Key, N-Null, X,Y,Z - values)
K1 X N N N N K2 X N N N N --------------------------
Table2:
K1 N X N N N K2 N X N N N --------------------------
the other 3 tables are in the same way.
But there can be a situation like any of the table can contain duplicates like:
K1 X N N N N K1 Y N N N N --------------------------
This kind of records should be errored out.
Because of this, we can't use aggregator/group by as we are not sure which one should be removed.
How can we obtain this functionality in Informatica.
|
|
View Answer |
|
What r the basic needs to join two sources in a source qualifier?
|
|
View Answer |
|
About Informatica Power center 7: 1) I want to Know which mapping properties can be overridden on a Session Task level. 2)Know what types of permissions are needed to run and schedule Work flows.
|
|
View Answer |
|
What is the default join that source qualifier provides?
|
|
View Answer |
|
What r the options in the target session of update strategy transsformatioin?
|
|
View Answer |
|
What is the difference between PowerCenter 6 and powercenter 7?
|
|
View Answer |
|
What is the Rankindex in Ranktransformation?
|
|
View Answer |
|
What is the need and when do we use a dynamic lookup cache? |
|
View Answer |
|
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
|
|
View Answer |
|
What is meant by EDW?
|
|
View Answer |
|
can any one comment on
significance of oracle 9i in informatica when compared to oracle 8 or 8i.
I mean how is oracle 9i advantageous when compared to oracle 8 or 8i when used in informatica
|
|
View Answer |
|
Why dimenstion tables are denormalized in nature ?
|
|
View Answer |
|
I have windows xp. I was told a person could find out what sites a person is looking on your computer. How do you do this. I have a person who uses my computer, and I think he is looking at sites he should not be viewing. |
|
View Answer |
|
With out using Updatestretagy and sessons options, how we can do the update our target table?
|
|
View Answer |
|
What is Load Manager?
|
|
View Answer |
|
In a filter expression we want to compare one date field with a db2 system field CURRENT DATE. Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator).. Can someone help us. Thanks
|
|
View Answer |