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?
1768In 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 5981In 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 7862Display 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 16140Hi 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 16932Program 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.
5043A 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?
910A 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?
885Post New iNautix Interview Questions
Say when to pick “inward table” and “outside table” in hive?
which one is more flexibility and reliability and durability asp.net (VS)php which one is best and which one we do nice to create dynamic websites
What does the following sql error -1000 mean: too many lock requests?
Does apache use php?
Do we need a special driver to access data within hana? : hana modeling
Explain “not null constraint” in sql server?
How crm can handle e-mails from customers?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is difference between calling start() and run() method of thread?
What is your understanding of peoplesoft hrms system data regulation?
Explain mechanism of fatigue failure.
what is the meaning of MIN MAX?
How can I copy the name of the worksheet tab to a cell in the worksheet?
how to implement data validations?
What is a data structure definition?