Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6119 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
How to handle decimal places while importing a flatfile into informatica?
How do you promote a non-reusable transformation to reusable transformation?
Explain what transformation and how many are there in informatica?
How we can use union transformation?
Please let me know how to make Data masking in informatica..
what is degenerated dimension?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the surrogate key?
Can informatica load heterogeneous targets from heterogeneous sources?
What is aggregator transformation in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Performance tuning in UNIX for informatica mappings?
Explain the pipeline partition with real time example?
What is meant by incremental aggregation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
