Answer / infa_geek

Integration Service follows instructions coded into Update
Strategy and Custom transformations within the session
mapping to determine how to flag rows for insert, delete,
update, or reject.
If the mapping for the session contains an Update Strategy
transformation, this field is marked Data Driven by
default.
If you do not choose Data Driven when a mapping contains an
Update Strategy or Custom transformation, the Workflow
Manager displays a warning.

Answer / srinu

data driven is a set of rules.based upon this rules the
integration service perfoms all operations in update
strategy transformation.
DD_INSERT
DD_UPDATE
DD_REJECT
DD_DELETE

What does role playing dimension mean?

0 Answers  

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---

What is joiner transformation?

0 Answers  

---

in performance wise union is past,union all is past

2 Answers  

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

What is a taget load order?

2 Answers   IBM,

---

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---