Interested to Buy Any Domain ? << Click Here >> for more details...
What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
- 8 Answers
- 25051 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rajkumar bachu
we can use Union Transformation to load multiple files into
single target.
| Is This Answer Correct ? | 4 Yes | 13 No |
Post New Answer View All Answers
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you handle two sessions in Informatica
What does cheating measurement mean?
What are the features of complex mapping?
Please let me know how to make encryption and decryption with example?
Explain the different dimensions.
Difference between Target-based loading and constraint-based loading?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
design of staging area?
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
What is an expression transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is an Integration service in Informatica?
What are session parameters ? How do you set them?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
