What is the main data object present inbetween source and
target. I answered Mapping. Transformation etc.. But it is
not the answer. So please give me an apt answer. Thanks in
advance
Answer Posted / santoshi
The main data object present inbetween source and target is
staging layer only, Staging layer will do eliminate the
inconsistency data and gives the result data object
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is informatica etl tool?
What is the different lookup cache(s)?
update strategy transformation in informatica
Explain sessions and how many types of sessions are there?
How will the document be delivered to me?
What all join we can perform in LOOKUP transformation?
What are the differences between source qualifier and joiner transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is a repository? And how to add it in an informatica client?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is Session and Batches?
How does a sorter cache works?
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