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
- 5284 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul
You can write the SQL statement for that particular
location in the source qualifier if it is a relational
table.
Use Filter if it is a flat file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a joiner transformation and why it is an active one?
what is the hint? how to use it to reduce the query processing in program?
What is transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is joiner transformation?
what are the deliverables?in your project?
What is an aggregator transformation?
Write the prerequisite tasks to achieve the session partition?
What is the sequence generator transformation in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How would you join a node to the already existing domain?
What are the restrictions of union transformation?
What are the different lookup cache(s)?
How can you generate reports in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
