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 8939My 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 8441i 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 6459my 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 6823How we will implement Pushdown Optimization and Types in Informatica with better examples
TCS,
4 12934in 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 11888i 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 10763Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
2 5655can we have to do changes in session property when we are dynamically generating target files?
3 8057Lookup 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,
2519Post New Informatica Questions
What are Dimensional table?
What is dimensional table? Explain the different dimensions.
How can we handle two sessions in informatica?
Explian the Process of deployment groups in informatica
What are mapplets?
How might you approve all mappings in the archive all the while?
Explain scd type 3 through mapping.
expain about the tune parameters?
What is meant by incremental aggregation?
update strategy transformation in informatica
can anyone explain me about retail domain project in informatica?
Slowly changing dimensions, types and where will you use them
what is the size of your data warehousing?
what are the deliverables?in your project?
How would you join a node to the already existing domain?
