What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
2365What is best approach to load 100 different source files (Different structure) to differet target tables ?
2 10978How 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 ?
2 10039If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
2 8900Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
1 3002I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
4 13329Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
1 3699Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
1796Post New IBM Informatica Interview Questions
What is cohesion explain with example?
How are composite and multiple indexes different?
How you can write testcases from requirements and do the requirements represents exact functionality of aut (application under test)?
what is the Hadoop MapReduce APIs contract for a key and value class?
What might be the reason if the status of the resource is showing as warning in the control room?
Can we write trigger for view?
what is sysdba and sysdbc ? which has high priority ?
Can hashmap have same key?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what happens if an .swf is loaded into a already occupied level? : adobe flex action script
what is the difference between char and varchar data types? : Sql dba
What is p in mkdir?
Which DSLAMs interoperate with the ADSL WIC?
Explain the basic structure of bootstrap framework?
Are you willing to travel? How much?