,if we have single SQ in flow and we have router in which it
has two group and we want to join these two groups with
joiner ?is it possible?
Answer Posted / mehul
Hi Sree
Could u please elaborate your solution
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the -ve test case in your project.
What are the data movement modes in informatica?
What does refresh system mean, and what are its distinctive choice?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the informatica performance improvement tips
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to do the error handling of if ur source is flatfiles?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Can informatica load heterogeneous targets from heterogeneous sources?
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
Can anyone tell me the new features in Informatica 9 Version?
Reusable transformation and shortcut differences
How many number of sessions can one group in batches?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is an active transformation?