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
- 6100 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
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is different between the data warehouse and data mart?
What is status code in informatica?
Does an informatica transformation support only aggregate expressions?
Is it possible to use a client with different version than that of its Informatica server?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is meant by LDAP users?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain the scenario which compels informatica server to reject files?
Clarify the utilization of aggregator cache record?
What is fact table? Explain the different kinds of facts.
Explain pushdown optimization and types in informatica
What is DR strategy for Informatica project?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Describe an informatica powercenter?
