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
- 16003 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 |
why dimenstion tables are denormalized in nature ?
lookup transformation with screenshots
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
.prm wirh repalce .txt is possible?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
Briefly explain the aggregator transformation?
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,
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What is the functionality of update strategy?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
Teradata 
