Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
- 6 Answers
- 15611 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reena
use sequence generator to get row no. for each record ,then
use filter giving the condition (row no.greater than 50 and
less than 100)
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / chakri
Use count variable
Use Variable port
Expression transformation
(Count>50) and (count<100)
Please let me know any information
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / gurava reddy
Source-SQ-SEQ-FILTER-TARGET
1.Connect the sequence genarater(NEXTVAL) to filter in filter
IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)
2. Then connect the ports to destination(Target)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / susanta
We can filter the records in UNIX itself, then we can use
that filterd file as a source to the mapping.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sujana
i dont think count works in dis scenario...first answer works
| Is This Answer Correct ? | 1 Yes | 3 No |
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
Differentiate between a repository server and a powerhouse?
Slowly changing dimensions, types and where will you use them
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
What do you mean by blocking transformation?
Is there any model difference between ODS and DWH
What is a repository? And how to add it in an informatica client?
Explain constraint based loading in informatica
Teradata 
