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.
Answer Posted / srini
Answers 1 and 4 right. Since the session will be executed
successfully but no rows will be loaded into the target.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
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 $$$$?
How can we update a record in the target table without using update strategy?
What are the components of the workflow manager?
During the running session, output files are created by informatica server. Enlist few of them.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is workflow manager?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Design time, run time. If you don't create parameter what will happen
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
tell me the rules and responsblites in our project(my project is development)
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What do you mean by worklet?