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 5765hi 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 8554While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
4 7488there 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 5823ename,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 4347can 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 16528Suppose 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 22074how to import multiple flat files in to single target where there is no common column in the flat files
TCS,
2 6289In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
1 8819We 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 5354Post New Informatica Questions
What is informatica?
To import the flat file definition into the designer where should the flat file be placed?
What are connected or unconnected transformations?
Differentiate between joiner and lookup transformation?
What is meant by query override?
Enlist the advantages of informatica.
What do you understand by SOA of Informatica?
define galaxy repository in informatica
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to update source definition?
Which development components of informatica have the highest usage?
How many numbers of sessions can one group in batches?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a sequence generator transformation?
Explain about Informatica server process that how it works relates to mapping variables?