What are the tasks that source qualifier performs?
Answer / swetha
Join data originating from same source data base.
Filter records when the informatica server reads source data.
Specify an outer join rather than the default inner join
specify sorted records.
Select only distinct values from the source.
Creating custom query to issue a special SELECT statement
for the informatica server to read source data.
Is This Answer Correct ? | 5 Yes | 1 No |
How to display null values on a target & non-null values on a target?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
What is meta data and system catalog?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
How do you implement scheduling in Informatica?
Write the prerequisite tasks to achieve the session partition?
What are the reusable transforamtions?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What is informatica?
Explain the types of lookup transformation?