Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 10233 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / upendra
sq--> srtr-->aggr-->tgt
note:
srtr->properties->
select distinct and connect to aggr tr
aggr-->group by key column
aggr->properties->select sorted input
and connect to tgt
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
Differentiate between joiner and lookup transformation?
How do you migrate data from one environment to another?
How to call shell scripts from informatica?
Did u used latest transformations of 8.6.0? for what?
What is update strategy transform?
What is the need of etl tools?
What is the use of an aggregator cache file?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the way to execute pl/sql script using informatica mapping?
Can we create two repositories on same database instance in oracle?
can we override a native sql query within informatica? How do we do it?
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?
Differences between version 7.x and 8.x.
what is the hint? how to use it to reduce the query processing in program?
