Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
2 6656hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
IBM,
9 10777While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
4 9061there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
TCS,
2 6711ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
IBM,
1 5122can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 17775Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
TCS,
15 26059how to import multiple flat files in to single target where there is no common column in the flat files
TCS,
2 7318In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
1 9600We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
2 6294Post New Informatica Questions
What is rank transformation?
What is the use of code page?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is SDLC way of code development?
How to do the error handling of if ur source is flatfiles?
How can you generate reports in informatica?
Explain the pipeline partition with real time example?
Explain lookup transformation source types in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
list out all the transformations which use cache?
What is joiner transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Do you find any difficulty while working with flat files as source and target?
While migrating the data from one environment to another environment how would you manage the connections?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.