|
Question |
Rating |
View Answer |
|
How can we eliminate duplicate rows from flat file?
|
|
View Answer |
|
How to Generate the Metadata Reports in Informatica?
|
|
View Answer |
|
In certain mapping there are four targets tg1,tg2,tg3 and tg4. tg1 has a primary key,tg2 foreign key referencing the tg1's primary key,tg3 has primary key that tg2 and tg4 refers as foreign key,tg2 has foreign key referencing primary key of tg4 ,the order in which the informatica will load the target? 2]How can I detect aggregate tranformation causing low performance?
|
|
View Answer |
|
What are the different types of transformation available in informatica. and what are the mostly used ones among them
|
|
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 is a view? How it is related to data independence?And what are the different types of views,and what is Materialize view
|
|
View Answer |
|
Can u tell me how to go for SCD's and its types.Where do we use them mostly
|
|
View Answer |
|
When do u we use dynamic cache and when do we use static cache in an connected and unconnected lookup transformation
|
|
View Answer |
|
Can any one tell me how to run scd1 bec it create two target tables in mapping window and there are only one table in warehouse designer(means target).. so if we create one new table in target it gives error..
|
|
View Answer |
|
How to export mappings to the production environment?
|
|
View Answer |
|
How u will create header and footer in target using informatica?
|
|
View Answer |
|
What is the difference between constraind base load ordering and target load plan
|
|
View Answer |
|
How do we analyse the data at database level?
|
|
View Answer |
|
Why sorter transformation is an active transformation?
|
|
View Answer |
|
How is the union transformation active transformation?
|
|
View Answer |
|
There are 3 depts in dept table and one with 100 people and 2nd with 5 and 3rd with some 30 and so. i want to diplay those deptno where more than 10 people exists
|
|
View Answer |
|
What is tracing level?
|
|
View Answer |
|
Can we eliminate duplicate rows by using filter and router transformation ?if so explain me in detail .
|
|
View Answer |
|
How can we join 3 database like Flat File, Oracle, Db2 in Informatrica..
|
|
View Answer |
|
Is a fact table normalized or de-normalized?
|
|
View Answer |