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 5811hi 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 8612While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
4 7550there 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 5849ename,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 4371can 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 16572Suppose 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 22169how to import multiple flat files in to single target where there is no common column in the flat files
TCS,
2 6328In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
1 8848We 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 5384Post New Informatica Questions
What is persistent lookup cache?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Separate from an archive server and a powerhouse?
How we can create indexes after completing the loan process?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is dimensional table?
can u any challenge your project?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain what are the different versions of informatica?
Briefly define reusable transformation?
What is status code in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the use of target designer?
Explain target update override in informatica
Differentiate between a database and data warehouse?
