whatis the default data driven operation in informatica
- 2 Answers
- 6226 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / umarao
This is defauly option for update strategy transformation.
The intigrationservice follows instructions coded in update
stategy within session mapping detarmine how to flag
records for insert,delete,update,reject.if you do not
datadriven option setting,the integration service ignores
update strategy transformations in the mapping.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the Rank index port in Rank transformation?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How can we eliminate duplicate rows from flatfile,explain?
What are differences between Informatica 7.1 and 6.1
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
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.
why do u use shortcuts in informatica.?
How to do unit testing in informatica? How to load data in informatica ?
Two different admin users created for repository are ______ and_______
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Enlist the advantages of informatica.
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
Teradata 
