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 8579My 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 8103i 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 5905my 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 6412How we will implement Pushdown Optimization and Types in Informatica with better examples
TCS,
4 12537in 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 11331i 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 10263Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
2 5429can we have to do changes in session property when we are dynamically generating target files?
3 7734Lookup 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,
2414Post New Informatica Questions
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is a node in Informatica?
What is the difference between informatica 7.0 and 8.0?
What are mapplets? How is it different from a Reusable Transformation?
What is meant by incremental aggregation?
What is an expression transformation in informatica?
What is sequence generator transformation in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is sq transformation?
Which development components of informatica have the highest usage?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Write the prerequisite tasks to achieve the session partition?
What are the different lookup cache(s)?
if we have a delimiters at unwanted places in a flat file how can we over come those.
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you