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
- 5502 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
Design time, run time. If you don't create parameter what will happen
Explain the etl program with few examples.
What is the format of informatica objects in a repository?
Explain the pipeline partition with real time example?
Write the program through which the records can be updated?
Difference between Target-based loading and constraint-based loading?
Can informatica load heterogeneous targets from heterogeneous sources?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is the difference between informatica6.1 and infomatica7.1
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain the difference between mapping parameter and mapping variable?
How to create a non-reusable instance of reusable transformations?
Under what condition selecting sorted input in aggregator may fail the session?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
