Interested to Buy Any Domain ? << Click Here >> for more details...
How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 9802 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / yaseen
After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
what is the size of u r source(like file or table)?
What is the Process to creating lookup transformation in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the guidelines to be followed while using union transformation?
explan ur project architecture?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a connected transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Informatica settings are available in which file?
How can you differentiate between powercenter and power map?
Write the prerequisite tasks to achieve the session partition?
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
