What are the types of data that passes between informatica
server and stored procedure?
Answer / swetha
3 types of data
Input/Out put parameters
Return Values
Status code.
| Is This Answer Correct ? | 4 Yes | 0 No |
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
If we have lookup table in workflow how do you trouble shhot to increase performance?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
any body can say about all versions of informatica ?how many versions ?
What are the connected or unconnected transforamations?
What is option by which we can run all the sessions in a batch simultaneously?
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 to join three sources using joiner?
How You Pull the records on daily basis into your ETL Server.
How can we update a record in the target table without using update strategy?
Enlist the advantages of informatica.