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?
2253In 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 6780In 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 9574Display 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 18036Hi 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 18569Program 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.
5790A 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?
1642A 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?
1502Post New iNautix Interview Questions
A form has four mandatory fields to be entered before you submit. How many numbers of test cases are required to verify this? And what are they?
Can I downgrade windows 10 64bit to 32bit?
where are the documents and settings for the roaming profile stored? : Windows server 2003
What is jdbc url for mysql?
What is meant by nested loop?
Which metals do not react with lithium bromide ad why?
What are the application of bernoulli’s theorem?
What do you mean by const correctness?
What causes turbocharger surging?
How to drop an existing table in mysql?
What is rs test why we are performing rs test?
What are the pros and cons of using circuit switching?
Which is better csv or excel?
what is Ruby on Rails?
Is it possible to measure correct value of earth resistance & cable insulation ristance with out disconncting earth lead & both sides of cable ends? If not, any other method to measure ER & CIR with out disconneting from the system.