WHat all joins are there in Source Qualifier?
Answer / pr
The default join is inner join. But we can override it by using the SQL overide query and can perform any joins
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the use of Java Transformation in Informatica 8.x?
What is a transaction control transformation?
What is parameter file?
tell me 7.x and 8.x diferrencess(but not transformations)
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What are the options in the target session of update strategy transsformatioin?
star and snowflake schema?
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 ?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Define the various join types of joiner transformation?
What are the types of lookup transformation?
How will u find weather dimension table is big in size of a fact table?