we have table like cust_id,cust_name,cust_loc like this
1.we need to get perticular location,to do this we can use
filter transformatin,that logic is same for relation table
and flat file tabl?
- 2 Answers
- 5258 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreenu
yes
but if it is a relational table beter to use SQL overried
for performence
for flat files u have to use filter t/r
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the informatica workflow?
What is standalone command task?
Can we create multiple integration service on single repository?
How to generate sequence numbers using expression transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is fact table? Explain the different kinds of facts.
Separate from a database, an information bazaar, and an information stockroom?
waht type of interface is used for testing the data in informatica
How can you validate all mappings in the repository simultaneously?
How to load the data from a flat file into the target where the source flat file name changes daily?
How would you join a node to the already existing domain?
wf dont have integration severances how you can run?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain sql transformation in script mode examples in informatica
What are mapplets? How is it different from a Reusable Transformation?
