Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
- 2 Answers
- 6328 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari
create mapping like
source -- sorter -- expression -- filter -- target.
here sorter is used to send data by ascending order data
this is not mandatory.
Expression is need to create variable port which will count
the rows which are comming in.
Filter having condition like if count value >=51 and count
value <= 100.
| Is This Answer Correct ? | 6 Yes | 0 No |
Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target
src--->sq---> expression--->filter--->target
| Is This Answer Correct ? | 1 Yes | 0 No |
While importing the relational source defintion from database,what are the meta data of source U import?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
What are the different types of olap? Give an example?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What are the guidelines to be followed while using union transformation?
How do you implement scheduling in Informatica?
What is partioning?how many types of partinings are there
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
Can yoU use the maping parameters or variables created in one maping into another maping?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
What is data merging, data cleansing and sampling?
Teradata 
