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?
1781In 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 5999In 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 7917Display 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 16198Hi 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 16993Program 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.
5065A 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?
929A 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?
911Post New iNautix Interview Questions
How do you persuade people?
Explain the difference between hashmap and hashtable in java?
which batch require to use for analytical method validation?
What is the zone in DNS?
how to shutdown mysql server? : Sql dba
Explain under what type of account does the unearned revenues fall?
How do you know if sql server is running on your local system?
how to convert dates to character strings? : Sql dba
Explain different kinds of Switching techniques.
What is argument in excel?
Explain data types in c#?
What is PreDef in Scala?
Dear Sir, i need previous technical question papers, if possible so please tell from where i got these papers.
What is a initialization parameter file in oracle?
Can we edit a view in sql?