How you count the number of records available at your source?
Answer Posted / venkat
Use aggregator transformation for getting number of record
count from source.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
Describe expression transformation?
What is a connected transformation?
Can we override a native sql query within informatica?
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 the size of u r source(like file or table)?
Performance tuning( what you did in performance tuning)
What is informatica? Why do we need it?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are Dimensional table?
Explain the etl program with few examples.
State the limitations where we cannot use joiner in the mapping pipeline?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to differentiate between the active and passive transformations?
What are the types of lookup transformation?