how can import the data from the flat files?
Answers were Sorted based on User's Feedback
Answer / immu
Source Analyzer---->click on import from file---->select file
| Is This Answer Correct ? | 1 Yes | 0 No |
How to create Target definition for flat files?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is a poling?
In a sequential batch can you run the session if previous session fails?
What is the format of informatica objects in a repository?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
how you will maintain version?
What is session task and command task?
what is update strategy transformation ?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.