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
- 5764 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
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the format of informatica objects in a repository?
What is confirmed fact in dataware housing?
how we can load rejected record's at run time?(not through bad files)
What if the source is a flat-file?
What are the components of workflow manager?
what is diff b/t sorter t/r and agg have the option sorter property...
how tokens will generate?
What is the meaning of decode in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to update source definition?
Can we create multiple integration service on single repository?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain in detail about scd type 1 through mapping.
