If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
2178In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
1 6634In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
5 9172Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.
3 17684Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
3 18267Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.
5672A man ate 100 bananas in five days, each day eating 6 more than the previous day. How many bananas did he eat on the first day?
1516A monkey starts climbing up a tree 20ft. tall. Each hour, it hops 3ft. and slips back 2ft. How much time would it take the monkey to reach the top?
1384Post New iNautix Interview Questions
Why the unit sizes of hydro generating machines are not standardized as in case of thermal powerplants?
If symmetrical fault occurs at the terminal of a synchronous motor then how the motor will act...explain it..
What do you mean by structural authorization?
what are your current financial and accounting projects? What is your role?
How can you reference current thread of the method ?
ht side line to earth voltage
Differentiate between managed and unmanaged code?
What is hibernate model class?
Define what are the reasons why one should not hack WordPress core file?
What are mpfi and tpfc systems?
what is raid in windows server 2008? : Windows server 2008
What is where clause in oracle?
What is optional binding?
Routers are used in which layers?
What are the steps involved in etl process?