What are the tasks that source qualifier performs?
- 1 Answers
- 6591 Views
- I also Faced
- E-Mail Answers
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 |
Why use shortcuts(Instead of making copies).
What is the use of incremental aggregation?
4 yrs etl devloper roles and responsibilities?any body give solutions
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
As union transformation gives UNION ALL output, how you will get the UNION output?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
how to create user defined function (udf) in informatica
If we are using an aggregator but forget to mention the group by port .what will be the output??
Which kind of index is preferred in DWH?
what is shared Cache. when we will use shared Cache?
why union is active transformation?
Teradata 
