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 7869Display 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 16149Hi 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 16938Program 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.
5049A 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?
913A 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?
888Post New iNautix Interview Questions
Define period work schedules?
How do I add a column to an existing table in db2?
how ceiling fan worked?
List non –mm objects that must be replicated in srm system.
What is an analogy for microtubules?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is mvc life cycle?
Is json a nosql?
What is the use of safe mode in android?
i have design dc-dc 3-way isolator circuit,how to test psrr,response time,limit frequency
How to use updateorinsert() method in laravel query?
What is the use of stringr package. Give some examples of the functions in stringr.
What is a Pivot?
Is there any class in javascript?
How is it possible to apply 2 different overhead rates for 2 different finished goods?