Interested to Buy Any Domain ? << Click Here >> for more details...
Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
- 3 Answers
- 9066 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / anu
Select distinct in sorter t/r
then run session twice
but don't enable truncate option in session target properties
I think so
any corrections tell me
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is deployment group?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is joiner transformation?
What are the components of workflow manager?
What are the databases that informatica can connect to windows?
Enlist few areas or real-time situations where informatica is required.
Have you worked with/created Parameter file
How to update or delete the rows in a target, which do not have key fields?
How to load last n records of file into target table - informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
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
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to call shell scripts from informatica?
