How to load the source table into flat file target(with
columns) in informatica?
Answer Posted / madhavi
To load the source table and fact table by using import from databae or flat file
Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
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)
Briefly explain the aggregator transformation?
What do mean by local and global repository?
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 .
Define enterprise data warehousing?
Difference between Target-based loading and constraint-based loading?
explain about unit testing? in real time?
How to generate or load values in to the target table based on a column value using informatica etl tool.
In informatica workflow manager, how many repositories can be created?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is transformation?
Define mapping and session?
Define sessions in informatica etl?
What does update strategy mean, and what are the different option of it?
What are active transformations.