what are the output files that the informatica server creats during running a session?2 6314
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure2 5062
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?6 9817
how you will maintain version?3 5764
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?2 2061
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.1 1622
Limitation of REPLACESTR. Is there any character limitation to it.1 1684
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .2 2177
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how430
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?458
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.430
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.512
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).425
Difference of Console, web & windows applications?
I have mentioned the buyer as in Kolkata and the consignee's in Jharkhand now the consignee has issued the C Form whether the C Forms is acceptable or not kindly help me
what is the mode of method of face bar measurement
What is the use of Differ interface check box in Ship confirm?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Which Class insulation is prefered for the sandwich Busducts ? Why?
Difference between sql and mysql?
What is an Event Queue?
What is the difference between header and line level values?
How we will test ubercate
How can I automate database maintenance routines?
through which phases a software ttester need to pass like as a junnior test engineer,team lead,project lead,etc.? which is the final stage of your promotion and how will u achieve?
What is the difference between tcp/ip protocol and IP protocol?
As we use capacitior bank in 3ph ckt for improvement of PF, why not we use capacitor in single phase domestric use, at our house their are many inductive equipments,like fan,mixer,tube choke,air conditioner they also draw PF... by using capacitor can they improve PF. if yes--what are advantage and how to connect a capactor in single ph,and which type of capacitor if no- what are disadvantages.
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)