How to load last 10 records of flat file in to the target?
Answer Posted / prasad
hi,
i am new for informatica. can u write condition in
filter t/f please.......
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are the main features of Oracle 8i with context to datawarehouse?
What are the different clients of powercenter?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Which development components of informatica have the highest usage?
Explain the types of transformations?
server hot-ws270 is connect to Repository B. What does it mean?
What are the different components of powercenter?
How might you approve all mappings in the archive all the while?
What is the difference between informatica 7.0 and 8.0?
What is the use of target designer?
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 do you remove duplicate records in informatica? And how many ways are there to do it?
can anyone suggest best free Talend data integration training online
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?