Interested to Buy Any Domain ? << Click Here >> for more details...
without update strategy how to insert &update?
- 1 Answers
- 6569 Views
- DELL, I also Faced
- E-Mail Answers
Answer / nivas
First you create the mapping according to your requirement
after that you create session.
Double click the session and then select properties tab in
the properties tab choose Target Rows Source as what do you
want (Insert, update,delete, Datadriven(this is only when
your using update stratogy transformation in the mapping)).
| Is This Answer Correct ? | 6 Yes | 0 No |
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
What are conformed dimensions?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Kimball and Inmon methodologies?
What is intricate mapping?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
explain different types of modeling.
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
Describe the impact of several join conditions and join order in a joiner transformation?
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
What is the cumulative sum and moving sum?
Teradata 
