how can import the data from the flat files?
Answers were Sorted based on User's Feedback
Answer / immu
Source Analyzer---->click on import from file---->select file
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the necessity to use update strategy?(except for updates)
If you want to create indexes after the load process which transformation you choose?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
normalizer transformation
What is an expression transformation in informatica?
What is meant by query override?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What is a transaction control transformation?
Mention few advantages of router transformation over filter transformation.
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
How to update or delete the rows in a target, which do not have key fields?