Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / gm
1.Why should we need to delete record from flat file?
Procedure:
We can Ignore record thru expression.
For Exp; Invalid Date, empty values some rows, etc..
Regards
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Define filter transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is main use of mapplet?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the use of code page?
Briefly define a session task?
What is the function of look up transformation?
What will be the approach?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
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.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Where are the source flat files kept before running the session?
What are the main features of Oracle 8i with context to datawarehouse?
Does an informatica transformation support only aggregate expressions?
