what are types of dimentions?
Answers were Sorted based on User's Feedback
Answer / yash
1. Uni Dimension
2. Junk Dimension
3. Hanging Dimension
4. Confirmed Dimension
5. SCD (A property of Dimension)
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a configuration management?
lookup transformation with screenshots
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
How many joins in Informatica
What is status code in informatica?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how can u tune u r informatica mapppings
in performance wise union is past,union all is past
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
Which transformation is needed while using the Cobol sources as source definitions?