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


Please Help Members By Posting Answers For Below Questions

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)

1361


Briefly explain the aggregator transformation?

785


What do mean by local and global repository?

929


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 .

1699


Define enterprise data warehousing?

870


Difference between Target-based loading and constraint-based loading?

761


explain about unit testing? in real time?

1914


How to generate or load values in to the target table based on a column value using informatica etl tool.

838


In informatica workflow manager, how many repositories can be created?

1039


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

6892


What is transformation?

881


Define mapping and session?

786


Define sessions in informatica etl?

790


What does update strategy mean, and what are the different option of it?

847


What are active transformations.

1413