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
- 5798 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
differences between service based and product based?
What does cheating measurement mean?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you load only null records into target?
How do you convert single row from source into three rows into target?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the different versions of informatica?
COM components can be used in Informatica
What is meant by pre and post session shell command?
Where are the source flat files kept before running the session?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Sequence generator, when you move from develoment to production how will you reset
What is fact table? Explain the different kinds of facts.
What is decode in static cache?
How to do unit testing in informatica?
