Interested to Buy Any Domain ? << Click Here >> for more details...
What is best approach to load 100 different source files
(Different structure) to differet target tables ?
- 2 Answers
- 10978 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahesh manam
For different source and different target you can make all
the mappings in ONE mapping.
And create a session for that mapping and you can call it.
If you have any constraints to load from particular target
and than some other target like wise any priority than
mention target load in mapping level
(Mappings --> target load plan --> give your priority)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / manojkumar challagundla
Yes you are correct.
Am just checking here like is there any better approach.
Thank you
| Is This Answer Correct ? | 1 Yes | 0 No |
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 get max value record into one target and remaining records into another target?
What is an unconnected transformation?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
How to recover sessions in concurrent batches?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
Which means the first record should come as last record and last record should come as first record and load into the target file?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
What is DTM process?
Teradata 
