WHat all joins are there in Source Qualifier?
- 1 Answers
- 1949 Views
- I also Faced
- E-Mail Answers
Answer / pr
The default join is inner join. But we can override it by using the SQL overide query and can perform any joins
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a passive transformation?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
What are the different lookup cache(s)?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What are the tasks that can be performed using sq?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
what is the logic will you implement to load data into a fact table from n dimension tables?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
Teradata 
