for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.
Answers were Sorted based on User's Feedback
Answer / sai krishna karri
only the answer 3 given by Amit is the valid answer.
| Is This Answer Correct ? | 0 Yes | 8 No |
Write the unconnected lookup syntax and how to return more than one column.
Can we use the mapping parameters or variables created in one mapping into another mapping?
Is there any model difference between ODS and DWH
A session S_MAP1 is in Repository A. While running the session error message has displayed
What are the rank caches?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
why we r using presql&postsql in source qualifier?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
I have source like this 1:2;3. so i want to load the target as 123
How might one distinguish in the case of mapping is right or not without associating session?
What is dimensional table?
Which is costliest transformation? costly means occupying more memory?