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 |
how remove 1st 3 records & last 3 records in informatics
How to load only the first and last record of a flat file into the target?
What is enterprise data warehousing?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
Could any one to tell Fact table Partitioning?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what are cost based and rule based approaches and what is the difference?
What is the difference between writing a joiner query in ANSI style and THETA style?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can you differentiate between powercenter and power map?
In which scenario did you used pushdown optimization?