| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to recover sessions in concurrent batches? | | 2 |
| if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh
the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)
| iFlex | 2 |
| What is staging area? | | 5 |
| .prm wirh repalce .txt is possible? | | 2 |
| What are the basic needs to join two sources in a source
qualifier? | | 3 |
| hw cn v elimate dublicate values from lookup without
overriding sql? | CTS | 6 |
| In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use? | | 1 |
| for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen. | Accenture | 10 |
| What are the session parameters? | | 2 |
| what is fact table? | | 6 |
| When do we use dynamic cache and static cache in connected
and unconnected lookup transformations? | | 3 |
| how do u move the code from development to production? | | 2 |
| Flat file heaving 1 lack records and I want to push 52000
records to the target? | | 6 |
| Can you copy the session to a different folder or
repository? | | 2 |
| What are Dimensions and various types of Dimensions? | | 2 |
| How can yoU improve session performance in aggregator
transformation? | | 6 |
| What are the types of metadata that stores in repository? | | 1 |
| What are the circumstances that infromatica server results
an unreciverable session? | | 1 |
| what is diff between grep and find | iFlex | 1 |
| how do u get the first record from 50,000 records ? | TCS | 5 |
| |
| For more Informatica Interview Questions Click Here |