My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
3 9676My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
HP,
3 9124i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
3 7593my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
HP,
3 7661How we will implement Pushdown Optimization and Types in Informatica with better examples
TCS,
4 13875in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
5 13055i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
5 11765Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
2 6151can we have to do changes in session property when we are dynamically generating target files?
3 8877Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
IBM,
1 2911Post New Informatica Questions
What are the different ways to implement parallel processing in informatica?
In how many ways we can create ports?
What is the function of aggregator transformation?
what is Active lock explain
Describe an informatica powercenter?
Enlist few areas or real-time situations where informatica is required.
Explain dynamic target flat file name generation in informatica
Explain the different kinds of facts.
Explain the pipeline partition with real time example?
What are junk dimensions?
What is a dimensional model?
How do you use reject loader.
Where do we use mapping variables in informatica?
How many dimensions are there in informatica?
What all join we can perform in LOOKUP transformation?