To achieve the session partition what r the necessary tasks
u have to do?
Answer / swetha
Configure the session to partition source data.
Install the informatica server on a machine with multiple CPU's.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is a surrogate key?
In real time scenario where can we use mapping parameters and variables?
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
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Write the advantages of partitioning a session?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
How to load the data from people soft hrm to people soft erm using informatica?
How to generate sequence numbers?
What is decode in informatica?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
What differs when we choose the sorted input for aggregator transformation?
Define joiner transformation?