What is source qualifier transformation?
Answer / swetha
When yoU add a relational or a flat file source definition
to a maping, yoU need to connect it to a source qualifer
transformation. The source qualifier transformation
represnets the records that the informatica server reads
when it runs a session.
Is This Answer Correct ? | 1 Yes | 0 No |
How to load data in informatica ?
What is substr in informatica?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
What is flashback table ? Advance thanks
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
What is a passive transformation?
Enterprise data warehouse your projects phase by phase explain?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
How you know when to use a static cache and dynamic cache in lookup transformation?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance