What is update override?
Answer / abhinav
Update Override is an option in Informatica at the session
level. In this, you can manually enter the SQL query to be
used. This query will be issued to the Database when the
session is run, overriding the SQL query generated by that
particular transformation at the mapping level.
| Is This Answer Correct ? | 9 Yes | 0 No |
How to generate or load values in to the target table based on a column value using informatica etl tool.
Tell me about Propagate functions in informatica
How many ways are there to create ports?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
What is a passive transformation?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
can we load the data with out a primary key of a table? what is target plan?
How do you update the records with or without using update strategy?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
hw cn v elimate dublicate values from lookup without overriding sql?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...