Interested to Buy Any Domain ? << Click Here >> for more details...
Update strategy transformation is an active
transformation.How it changes the number of records that
pass through it? Please explain....
- 2 Answers
- 21146 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jaimeen shah
You can configure the Update Strategy transformation to
either pass rejected rows to the next
transformation or drop them based on the update strategy
expression. By default, the PowerCenter Server forwards
rejected rows to the next transformation. The PowerCenter
Server flags the rows for reject and writes them to
the session reject file. If you do not select Forward
Rejected Rows, the PowerCenter Server
drops rejected rows and writes them to the session log file.
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / kondareddy
for example take one condition in update strategy
source we have 20 records. in that records we have 4 records has less then 500 salary
in update strategy condition is
iif(sal<500,3,sal) based on that condition only 15 records stored into target. so it will be effected on rows. becoz in update strategy 3 indicates rejected records....
so it is active....
| Is This Answer Correct ? | 0 Yes | 1 No |
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
How do you load only null records into target?
How would you join a node to the already existing domain?
What is repository manager?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
Can we get 1st record through Informatica(without sequence number).
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
whats the logic to load the lower level of granularity of data to fact table.
What is a surrogate key?
Please let me know how to make Data masking in informatica..
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Teradata 
