Answer Posted / usha
Status code provides error handling facility.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between writing a joiner query in ANSI style and THETA style?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is blocking transformation?
What is dimensional table?
What is meant by pre and post session shell command?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is informatica worklet?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is Cognos script editor?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is data caches/ index caches?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?